export const fieldType = [
  "tinyint",
  "smallint",
  "mediumint",
  "int",
  "integer",
  "bigint",
  "float",
  "double",
  "decimal",
  "date",
  "time",
  "datetime",
  "timestamp",
  "year",
  "char",
  "varchar",
  "binary",
  "varbinary",
  "tinyblob",
  "blob",
  "mediumblob",
  "longblob",
  "tinytext",
  "text",
  "mediumtext",
  "longtext",
  "enum",
  "set",
  "json",
  "geometry",
  "point",
  "linestring",
  "polygon",
  "multipoint",
  "multilinestring",
  "multipolygon",
  "geometrycollection",
];

export const fieldChar = {
  big5: ["big5_chinese_ci", "big5_bin"],
  dec8: ["dec8_swedish_ci", "dec8_bin"],
  cp850: ["cp850_general_ci", "cp850_bin"],
  hp8: ["hp8_english_ci", "hp8_bin"],
  koi8r: ["koi8r_general_ci", "koi8r_bin"],
  latin1: [
    "latin1_swedish_ci",
    "latin1_german1_ci",
    "latin1_danish_ci",
    "latin1_german2_ci",
    "latin1_bin",
    "latin1_general_ci",
    "latin1_general_cs",
    "latin1_spanish_ci",
  ],
  latin2: [
    "latin2_general_ci",
    "latin2_hungarian_ci",
    "latin2_croatian_ci",
    "latin2_bin",
  ],
  swe7: ["swe7_swedish_ci", "swe7_bin"],
  ascii: ["ascii_general_ci", "ascii_bin"],
  ujis: ["ujis_japanese_ci", "ujis_bin"],
  sjis: ["sjis_japanese_ci", "sjis_bin"],
  hebrew: ["hebrew_general_ci", "hebrew_bin"],
  tis620: ["tis620_thai_ci", "tis620_bin"],
  euckr: ["euckr_korean_ci", "euckr_bin"],
  koi8u: ["koi8u_general_ci", "koi8u_bin"],
  gb2312: ["gb2312_chinese_ci", "gb2312_bin"],
  greek: ["greek_general_ci", "greek_bin"],
  cp1250: [
    "cp1250_general_ci",
    "cp1250_croatian_ci",
    "cp1250_polish_ci",
    "cp1250_hungarian_ci",
    "cp1250_bin",
    "cp1250_czech_cs",
  ],
  gbk: ["gbk_chinese_ci", "gbk_bin"],
  latin5: ["latin5_turkish_ci", "latin5_bin"],
  armscii8: ["armscii8_general_ci", "armscii8_bin"],
  utf8: [
    "utf8_general_ci",
    "utf8_bin",
    "utf8_unicode_ci",
    "utf8_icelandic_ci",
    "utf8_latvian_ci",
    "utf8_romanian_ci",
    "utf8_slovenian_ci",
    "utf8_polish_ci",
    "utf8_estonian_ci",
    "utf8_spanish_ci",
    "utf8_swedish_ci",
    "utf8_turkish_ci",
    "utf8_czech_ci",
    "utf8_danish_ci",
    "utf8_lithuanian_ci",
    "utf8_slovak_ci",
    "utf8_spanish2_ci",
    "utf8_roman_ci",
    "utf8_persian_ci",
    "utf8_esperanto_ci",
    "utf8_hungarian_ci",
  ],
  ucs2: [
    "ucs2_general_ci",
    "ucs2_bin",
    "ucs2_unicode_ci",
    "ucs2_icelandic_ci",
    "ucs2_latvian_ci",
    "ucs2_romanian_ci",
    "ucs2_slovenian_ci",
    "ucs2_polish_ci",
    "ucs2_estonian_ci",
    "ucs2_spanish_ci",
    "ucs2_swedish_ci",
    "ucs2_turkish_ci",
    "ucs2_czech_ci",
    "ucs2_danish_ci",
    "ucs2_lithuanian_ci",
    "ucs2_slovak_ci",
    "ucs2_spanish2_ci",
    "ucs2_roman_ci",
    "ucs2_persian_ci",
    "ucs2_esperanto_ci",
    "ucs2_hungarian_ci",
  ],
  cp866: ["cp866_general_ci", "cp866_bin"],
  keybcs2: ["keybcs2_general_ci", "keybcs2_bin"],
  macce: ["macce_general_ci", "macce_bin"],
  macroman: ["macroman_general_ci", "macroman_bin"],
  cp852: ["cp852_general_ci", "cp852_bin"],
  latin7: [
    "latin7_general_ci",
    "latin7_estonian_cs",
    "latin7_general_cs",
    "latin7_bin",
  ],
  utf8mb4: [
    "utf8mb4_general_ci",
    "utf8mb4_bin",
    "utf8mb4_unicode_ci",
    "utf8mb4_icelandic_ci",
    "utf8mb4_latvian_ci",
    "utf8mb4_romanian_ci",
    "utf8mb4_slovenian_ci",
    "utf8mb4_polish_ci",
    "utf8mb4_estonian_ci",
    "utf8mb4_spanish_ci",
    "utf8mb4_swedish_ci",
    "utf8mb4_turkish_ci",
    "utf8mb4_czech_ci",
    "utf8mb4_danish_ci",
    "utf8mb4_lithuanian_ci",
    "utf8mb4_slovak_ci",
    "utf8mb4_spanish2_ci",
    "utf8mb4_roman_ci",
    "utf8mb4_persian_ci",
    "utf8mb4_esperanto_ci",
    "utf8mb4_hungarian_ci",
  ],
  cp1251: [
    "cp1251_general_ci",
    "cp1251_bulgarian_ci",
    "cp1251_ukrainian_ci",
    "cp1251_bin",
    "cp1251_general_cs",
  ],
  utf16: [
    "utf16_general_ci",
    "utf16_bin",
    "utf16_unicode_ci",
    "utf16_icelandic_ci",
    "utf16_latvian_ci",
    "utf16_romanian_ci",
    "utf16_slovenian_ci",
    "utf16_polish_ci",
    "utf16_estonian_ci",
    "utf16_spanish_ci",
    "utf16_swedish_ci",
    "utf16_turkish_ci",
    "utf16_czech_ci",
    "utf16_danish_ci",
    "utf16_lithuanian_ci",
    "utf16_slovak_ci",
    "utf16_spanish2_ci",
    "utf16_roman_ci",
    "utf16_persian_ci",
    "utf16_esperanto_ci",
    "utf16_hungarian_ci",
  ],
  utf16le: ["utf16le_general_ci", "utf16le_bin"],
  cp1256: ["cp1256_general_ci", "cp1256_bin"],
  cp1257: ["cp1257_general_ci", "cp1257_lithuanian_ci", "cp1257_bin"],
  utf32: [
    "utf32_general_ci",
    "utf32_bin",
    "utf32_unicode_ci",
    "utf32_icelandic_ci",
    "utf32_latvian_ci",
    "utf32_romanian_ci",
    "utf32_slovenian_ci",
    "utf32_polish_ci",
    "utf32_estonian_ci",
    "utf32_spanish_ci",
    "utf32_swedish_ci",
    "utf32_turkish_ci",
    "utf32_czech_ci",
    "utf32_danish_ci",
    "utf32_lithuanian_ci",
    "utf32_slovak_ci",
    "utf32_spanish2_ci",
    "utf32_roman_ci",
    "utf32_persian_ci",
    "utf32_esperanto_ci",
    "utf32_hungarian_ci",
  ],
  binary: ["binary"],
  geostd8: ["geostd8_general_ci", "geostd8_bin"],
  cp932: ["cp932_japanese_ci", "cp932_bin"],
  eucjpms: ["eucjpms_japanese_ci", "eucjpms_bin"],
};
